import sqlite3

conn = sqlite3.connect('itts.db')
cursor = conn.cursor()

cursor.execute('SELECT asset_id, asset_name, device_composition FROM ASSET WHERE device_composition IS NOT NULL AND device_composition != ""')
rows = cursor.fetchall()

print(f'Found {len(rows)} rows with device_composition:')
for row in rows:
    print(f'{row[0]} | {row[1]} | {row[2]}')

conn.close()